2017年8月17日 — I'm worried about the server resources though, and am now wondering about striking a balance between 'speed' and 'not hogging all resources ...
2017年12月31日 — This means you can back up your database into the ether: BACKUP DATABASE MyDatabase TO DISK = 'NUL:' That seems like a terrible idea! It ...
2017年7月31日 — Run a normal log backup to a file, then delete the .trn file. Switch to simple mode; Run a log backup to nul. The first one is easy, but it's a ...
2017年6月5日 — BACKUP DATABASE Test TO DISK = 'NUL'. Then as far as SQL Server is concerned you took a backup, but the backup file is never actually created.
2009年3月17日 — The command is: backup database yourdatabase to disk = 'NUL:' with stats = 1. chavezalejandro. SSC Rookie. Points: 37. More actions. June 1, ...
2015年10月26日 — Taking backup is NUL device is as good as taking backup and deleting it. Since the backup is taken to a device, SQL would send it to the ...
2010年7月26日 — The thing to remember is that while your backup data goes nowhere, SQL Server still recognises it as a 'valid' backup. So if you are performing ...
2017年6月3日 — This is an informational message only. No user action is required. 訊息BACKUP DATABASE successfully processed 24323 pages in 0.382 seconds ( ...
2014年8月29日 — USE master go DROP DATABASE TestDB go CREATE DATABASE TestDB; --先做一次full backup BACKUP DATABASE TestDB TO DISK = 'nul'. image. 如果打成'null ...
